Release 10.1A: OpenEdge Data Management:
Database Administration

Lock Table

Displays status information about the lock table. For a description of the lock table and its functions, see Chapter 13, " Managing Performance." When you choose this menu option, PROMON gives you three choices:

Display all lock entries.
Display locks for one user.
Display locks for one RECID.

Figure 19–21 shows a sample Lock Table Status display.

11/01/035        Status: Lock Table 16:22 Usr Name Trans id Type Table RECID Flags Trans State 8    rgw     0         REC       -6   2592  S     L       Begin 8    rgw     0         REC       -67  6818  S     L       Active

Figure 19–21: PROMON Lock Table Status display

The display contains the following fields:

Usr — The user number of the user who owns the lock entry.
Name — The user name.
Trans id — The transaction id.
Type — The lock type (for example, REC, RGET).
Table — The table number.
RECID — The RECID of the record and lock table entry.
Flags — Table 19–12 lists the possible flags.

Table 19–12: Lock table flags 

Flag	Description
S	Share lock.
X	Exclusive lock.
U	Lock was upgraded from a share lock to an exclusive lock.
L	Limbo. Lock is being held until the transaction commits.
Q	Request is queued, and the user is waiting for a conflicting lock held by another user.
P	Purged.
H	Hold.

Trans State — Indicates the state of the transaction.